UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iuFVRKjS3i2El08qPVDq37v3nXyNMOVfDOdCJUikeTo='
WHERE
key_id = 'c870b2b386235b0d4f43985d8ad1016890687ed8efb78caadc7990b96ce4ec81'
AND (
token = 'iuFVRKjS3i2El08qPVDq37v3nXyNMOVfDOdCJUikeTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)