UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7MlCl0HED1+nNKWOEVe1A7In8wAdy/Fq3NcF8Z2+amA='
WHERE
key_id = '77bd22107315b84c4477271fa780973a3dd11fbeb1cf863667c887d35aa2f0ed'
AND (
token = '7MlCl0HED1+nNKWOEVe1A7In8wAdy/Fq3NcF8Z2+amA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)