UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zJY41boD4RFnapNOhSb2YIgD9nfWpW9mrlTnYynoX8='
WHERE
key_id = 'd70485bf31bffb99705133684562cb695168ed5e2c9a67e2fd499d2eaf13eb55'
AND (
token = '5zJY41boD4RFnapNOhSb2YIgD9nfWpW9mrlTnYynoX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)