UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfdyWKekx2+KlIgJHftA3Dg6y/jtwmtYIIeA1JX/OIo='
WHERE
key_id = '6bb9628c463e8bc3e9de8965348afea0d6ecdd51a551268a2bd5d6c53609e6d6'
AND (
token = 'pfdyWKekx2+KlIgJHftA3Dg6y/jtwmtYIIeA1JX/OIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)