UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ZBJt1bcKQj7cxUeqE4ayiPftvQQJGLMGj9dgiaB2Wg='
WHERE
key_id = '4fc8aed078f5397f860bee4413178ab8cd9e7ad736aedf67bdcf94ad0666df91'
AND (
token = '0ZBJt1bcKQj7cxUeqE4ayiPftvQQJGLMGj9dgiaB2Wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)