UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjO7K8ibfUc5Qr/WIKomJ/NV1EgTdEYUcDDvX5B0yHY='
WHERE
key_id = '6982c76059b771efca1925fe071640fc515ac9af148e54ace137752b89e410dd'
AND (
token = 'BjO7K8ibfUc5Qr/WIKomJ/NV1EgTdEYUcDDvX5B0yHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)