UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phAAnSM+XZZ+SB/6QMIK2H1EY8lGaGcZKvy4kdVprZE='
WHERE
key_id = 'c9ef407a792ee3281f03c593f5a1af9fd9bf5b79a49b9c0531c15257cd372356'
AND (
token = 'phAAnSM+XZZ+SB/6QMIK2H1EY8lGaGcZKvy4kdVprZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)