UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXxi/A2vFooZdBPuM5nEL+wyzGqwCTLu4yMv4YYAf4o='
WHERE
key_id = '3423cf6c6d9796cada7fd8f25e94337902adc727b031e758d2bc888f7579254c'
AND (
token = 'gXxi/A2vFooZdBPuM5nEL+wyzGqwCTLu4yMv4YYAf4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)