UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zLLOAUvkbOwBA7XE4QOHwfJszYfYaoTPAVdoXx0HLdw='
WHERE
key_id = '1b1f7189f68132c1315f5d65a5f223c98fdb493ba1ad6b7f5cfef4dec7efc6e3'
AND (
token = 'zLLOAUvkbOwBA7XE4QOHwfJszYfYaoTPAVdoXx0HLdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)