UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yr+ZQ6+NwArN8BP13SzegJy6VfYTovg3LFg0U+gMtI8='
WHERE
key_id = 'cd88bd2e5812320137026881001e55deba7d1dadd4f69411819d3e1b3c1c767a'
AND (
token = 'yr+ZQ6+NwArN8BP13SzegJy6VfYTovg3LFg0U+gMtI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)