UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AiyPI9frTMXXDoQPLk3WYdmk3mOF5jk6zb9Fqt42jPI='
WHERE
key_id = '4cc92e9076246b31f3f2a920087e8a1f14bd9f99fe8671c47889bf726106e500'
AND (
token = 'AiyPI9frTMXXDoQPLk3WYdmk3mOF5jk6zb9Fqt42jPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)