UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p2zIk5eHzbyTBkYmnFXFe0msIlSYA16qWCao+cKnDk='
WHERE
key_id = '781d3a259d7a1c08fec0a8303e4f4d8767bbc66d19222b67a3fc7fe2c5717234'
AND (
token = '4p2zIk5eHzbyTBkYmnFXFe0msIlSYA16qWCao+cKnDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)