UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TYtugd78oHdXq4ZJuRT3M4mqkqPiJqkhu1yEt7EJilk='
WHERE
key_id = 'a13952d8ba45047ed4b7a94902ab143177bf34bcf0df0de30c5222c7643ffba1'
AND (
token = 'TYtugd78oHdXq4ZJuRT3M4mqkqPiJqkhu1yEt7EJilk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)