UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y1pjEdmxxhSWgF8HZMhE9GMdkdph6Z67xx6ZToFSbX0='
WHERE
key_id = '009040d3fde49cda33e9627c1877c7bf9177e22727c3e44f1d2a5f88c1deccb2'
AND (
token = 'y1pjEdmxxhSWgF8HZMhE9GMdkdph6Z67xx6ZToFSbX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)