UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xWBr96aJPBSd0mvschwSJnRWFjJtQpzbOurqhGNp17I='
WHERE
key_id = 'c9e8132e3be1add1004c7c76cf763c1f75c7c831646fe30736fd4b9f2b25c24f'
AND (
token = 'xWBr96aJPBSd0mvschwSJnRWFjJtQpzbOurqhGNp17I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)