UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ONUgwX2hLN2AbXt5DfMWXGd0oOaXNT4tcYJZapm4r8='
WHERE
key_id = 'ec6ee49c624e0b9eeac881b96fc2d434034fba0a93405d480e33c00d3dbad2cd'
AND (
token = '9ONUgwX2hLN2AbXt5DfMWXGd0oOaXNT4tcYJZapm4r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)