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