UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JaSnofV1oMc7J4m5Yf2dDq4gNOLFhxMFvxjoOHgCJNo='
WHERE
key_id = '062b5d427599adecd0dfa6ef053fc6a7fda52870ea0c08afb1f69d79e2ccfddb'
AND (
token = 'JaSnofV1oMc7J4m5Yf2dDq4gNOLFhxMFvxjoOHgCJNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)