UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'COXmA4BoGD6CQhLa2mYjvKixlVEgfZM/IhXZviRUcmA='
WHERE
key_id = '540df80c7ef0b3213a998a73103d6a6ef4675bb66c7d5ca966774f26e70039de'
AND (
token = 'COXmA4BoGD6CQhLa2mYjvKixlVEgfZM/IhXZviRUcmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)