UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Mwqi7FCmXhDdeT+K9YztiqozZcWU9xd5R1EjiqwXi0='
WHERE
key_id = '8f478c9c521576fd044aa80e7de83dd0adcfa83360310c0667b9bd2c41a919fc'
AND (
token = '8Mwqi7FCmXhDdeT+K9YztiqozZcWU9xd5R1EjiqwXi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)