UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DdR7lA/vxXhhEH0CVO+jfmry8rY5aWcBy4itvvZKd3I='
WHERE
key_id = '2acc4c9e5d4b93b41d747212f91f8c3d0dbef43cc188bc5770c58dbd6bfe7349'
AND (
token = 'DdR7lA/vxXhhEH0CVO+jfmry8rY5aWcBy4itvvZKd3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)