UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mgHLm95qNq1+BdUTjfzStVoBOA+FV+lS44XhU9nwzaw='
WHERE
key_id = 'f9b6177c094f293ebb971630a9c17f0b2189904d14cd44782aa0e16048e44866'
AND (
token = 'mgHLm95qNq1+BdUTjfzStVoBOA+FV+lS44XhU9nwzaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)