UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHgKqsxoPmhRSlxRimdJTgj2FzyEPmp//tc3AHHcBOI='
WHERE
key_id = '30966465b9010a29a26dc56f69a4c9d9af2aeb4cf2a72fff083fc4488f250cc7'
AND (
token = 'ZHgKqsxoPmhRSlxRimdJTgj2FzyEPmp//tc3AHHcBOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)