UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tm3Oj6I8cXQOkvn+BHGTynEjc2GkZmO/d41TA+9VBKw='
WHERE
key_id = 'd559332d30b8485f5c502beaa40005168b4c309adaa70b4c365e553ccc28daf5'
AND (
token = 'tm3Oj6I8cXQOkvn+BHGTynEjc2GkZmO/d41TA+9VBKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)