UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GkPbXHqSjFUUTclM7VTRO6EaLZbeHaj+P24Z+50HQc='
WHERE
key_id = '38ff8094471eca3b02e61ecc8949df02891e708ea755fbf6c2507933ac0545ab'
AND (
token = '0GkPbXHqSjFUUTclM7VTRO6EaLZbeHaj+P24Z+50HQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)