UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8Tcm14riN4xZYLzO7TQqKNfP7yZwQwnPUAcbOV/PQA='
WHERE
key_id = 'd117785122afe62d54b683d58733cea9e982c08850d4c8e42d007914c9ce1073'
AND (
token = 'B8Tcm14riN4xZYLzO7TQqKNfP7yZwQwnPUAcbOV/PQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)