UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8K5zIC4kO34rONr3tMgkYMd6pl9TkH0lqa9CKDs6d8k='
WHERE
key_id = '502215125bcf21d3864a9209081f0206dc2a1e2f23bca01c0c29538ebcae858f'
AND (
token = '8K5zIC4kO34rONr3tMgkYMd6pl9TkH0lqa9CKDs6d8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)