UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpNes2BHt8SsJCY23iKWSNotPVzYOwG6ctroB5u+6zE='
WHERE
key_id = '023984cb3649808aa8ca9aef57100f285fe6c555fb71e49a28298fc1ef4d2897'
AND (
token = 'SpNes2BHt8SsJCY23iKWSNotPVzYOwG6ctroB5u+6zE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)