UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oeFzdjWHxn2BQ0wmUEOr/LFNHQ9SynHtd9PHRgjAguk='
WHERE
key_id = 'ee10d6e1ab1a0b73a757f728af3f76997ad143429b9f5a808193fdab880feb1f'
AND (
token = 'oeFzdjWHxn2BQ0wmUEOr/LFNHQ9SynHtd9PHRgjAguk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)