UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bu8uJ2zyWVAU5pdlw5ybrWDYxGb8kGOr3Kk8iY5oXAo='
WHERE
key_id = 'a4d2e465d2bdafcbb827fb8d67095f37ad6fe94b4c91125ba8d2a79eb512d6e6'
AND (
token = 'Bu8uJ2zyWVAU5pdlw5ybrWDYxGb8kGOr3Kk8iY5oXAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)