UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Bt4BP6wOgYtXGRLWM7qk662MRdEAgvo8O/N8OnEHvU='
WHERE
key_id = 'a1470f8ffb48f258830f4d8f86d6bbec74e889f02bc7aef77ba83e90736a7c74'
AND (
token = '2Bt4BP6wOgYtXGRLWM7qk662MRdEAgvo8O/N8OnEHvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)