UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TdtsV6/g+7dF0sctfkNiN46Uq/XHVLYx6Jio+x8Q57c='
WHERE
key_id = 'a048d0c2e836f02a68497528c0c3401463c390ac66d8c14749f38b6b4a9c0192'
AND (
token = 'TdtsV6/g+7dF0sctfkNiN46Uq/XHVLYx6Jio+x8Q57c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)